CREATE EXTERNAL TABLE jms_dm.dm_cus_active_laxin2v_volume_cnt_dt(
  input_time date COMMENT '日期',
  customer_code string COMMENT '客户编码',
  customer_name string COMMENT '客户名称',
  waybill_cnt int COMMENT '客户发货量',
  acc_waybill_cnt int COMMENT '累计发货量',
  inviter_code string COMMENT '邀请人',
  date_time date COMMENT '查询日期')
COMMENT '拉新活动客户货量2.0'
PARTITIONED BY (dt string COMMENT '日期分区 yyyy-MM-dd,运单录入时间')
STORED AS PARQUET
LOCATION '/dw/hive/jms_dm.db/external/dm_cus_active_laxin2_volume_cnt_dt'
TBLPROPERTIES (
    'discover.partitions' = 'false',
    'parquet.column.index.access' = 'true'
);